Viewing 15 posts - 181 through 195 (of 536 total)
Nero-1119276 (10/26/2009)
sorry for providing incomplete information.My another system is in differenent geograhical location
What issues are you worried about? backup size/network link speed? No link between the two? ...
October 27, 2009 at 3:20 am
if i remember rightly there is one little "gotcha" in the maintenance plan cleanup job which is around the file extension. If i remember correctly you have to put...
October 26, 2009 at 1:59 pm
We use a program called synctoy to do this. its free and works like a dream. i would suggest though that if xcopy isnt working you either dont...
October 26, 2009 at 5:56 am
if you switch it back to full recovery model the next log backup you run will fail because the LSN sequence has been disrupted.
Read Gails (GilaMonsters) article on managing transaction...
October 22, 2009 at 9:52 am
try the shrink command another couple of times, sometimes it doesnt shrink. if it still doesnt change change your recovery model to simple, run the shrink again and then...
October 22, 2009 at 7:26 am
Krasavita (10/21/2009)
how can I shrink?
BACKUP LOG [MyDB] TO DISK = N'E:\sqldb\backup\\ChangeControl\MyDB_backup_200910220805.trn' WITH NOFORMAT, NOINIT
A full backup will not help here you here. you need to do a LOG...
October 22, 2009 at 1:48 am
ok your backup is going to be about 700mb. if its a dev box and you dont have room for the log backup i would just switch it to...
October 20, 2009 at 1:18 pm
Krasavita (10/20/2009)
This is a maintance plan: How much space do I need for transaction back?
depends on how much of the transaction log is used. run dbcc sqlperf (logspace) to...
October 20, 2009 at 9:20 am
is master..sqlbackup a procedure or a maintenance plan? i dont know off the top of my head if maint plans show in the error messages like that or not.
edit:...
October 20, 2009 at 9:10 am
you need to do a log backup if your recovery model is full/bulk logged. a full backup will not truncate your log file.
If you dont have the space to...
October 20, 2009 at 8:34 am
adam spencer (10/19/2009)
October 19, 2009 at 10:41 am
you cant just kill it because it has a large CPU usage. If your server has been online weeks/months etc you may have an app that uses one connection...
October 19, 2009 at 10:04 am
Richard M. (10/15/2009)
oops... right... missed out on the per processor license part 😀
it doesnt actually say, but as they had a proc license for 2000 i assumed they bought the...
October 15, 2009 at 8:49 am
Richard M. (10/15/2009)
...and the CAL's for 2005, if not already in possession.....
you dont need CALS for per processor licensing
October 15, 2009 at 8:41 am
rambilla4 (10/14/2009)
I have remembered that, we have 1 processor license for SQL Server 2000 Standard edition. Now we have Upgraded (In-place) it to SQL Server 2005 Enterprise edition. Now how...
October 15, 2009 at 1:58 am
Viewing 15 posts - 181 through 195 (of 536 total)