Viewing 15 posts - 16 through 30 (of 1,530 total)
:sick: didnt read the question fully. Thought OP was importing...
December 1, 2011 at 4:16 am
keep ur db in bulk logged recovery and then use bcp. this will be faster.
December 1, 2011 at 4:07 am
begining 2005, log backups can run simultaneously with full backups. Full backups do not block log backups.
When you change the recovery model from simple to full (for renabling log shipping),...
December 1, 2011 at 3:43 am
in the server name enter this.
192.168.147.25,1455
November 30, 2011 at 1:39 am
Try connecting with the ip address of the server.
ip,port
November 29, 2011 at 8:29 am
i have created database of that backup...i can view my table and its data too..now i want to get data from here to my server table from where i have...
November 29, 2011 at 1:37 am
engrshafiq4 (11/29/2011)
i can changed it to Full but what i do next?i want to recover my lost table data?what i do next...after i have my sqlserver in full mode
You cannot...
November 29, 2011 at 1:25 am
Long running Queries? Find their SPids and see what are they waiting on..
November 28, 2011 at 7:57 am
Backups do not interfare with other operations. Have you tried finding if there is any blocking during that period? You said the backups are on some shared drive (assuming...
November 28, 2011 at 6:34 am
This is normal. When SQL Server reaches a particular level of memory uses, It doesn't release it back to operating system unless there is memory pressure. Check your max memory...
November 28, 2011 at 6:02 am
Dev (11/28/2011)
1204 & 1222.Trace Flags (Transact-SQL)
1222 is for 2005 and above.
1204 will work in 2000.
November 28, 2011 at 5:57 am
GilaMonster (9/21/2011)
ps. (9/16/2011)
also, once any data/log file reaches a particular size, it wont free up space on it's own.
Errr, what???
Doesn't matter how large a log gets, assuming nothing is preventing...
September 21, 2011 at 8:35 am
Once a file reaches to a particular size, say 10 GB; even though the used space in the file is few MBs, the physical file size will remain at 10...
September 21, 2011 at 8:32 am
I imported the access db in a staging database. From there all conversions were smooth. database didnt have huge number of records so used normal select into statement with conditions...
September 21, 2011 at 7:55 am
Transactional Replication is the closest you can think of implementing at this stage.
You can also wait for some time before new version of sql server is released where in you...
September 17, 2011 at 8:59 pm
Viewing 15 posts - 16 through 30 (of 1,530 total)