Viewing 15 posts - 5,836 through 5,850 (of 7,191 total)
sudhakar0683 (6/8/2010)
You can use lite speed tool for backup,it was built in with sql server 2008
LiteSpeed is a good tool, but as far as I know it's not "built in"...
June 8, 2010 at 10:12 am
Iain
Yes, you need the name of the column that holds the date, instead of GETDATE(). The code you posted does not have a FROM clause. Please post the...
April 27, 2010 at 8:16 am
Radek
You can use the [font="Courier New"]WITH STATS =[/font] clause in your [font="Courier New"]RESTORE DATABASE [/font]statement in order to view the progress of the restore.
John
April 23, 2010 at 9:00 am
Good point from George about the failed restores. The change of ownership can be scripted, so I don't see that as an issue. You make your choice based...
March 23, 2010 at 9:13 am
george sibbald (3/23/2010)
mirroring might too, but not sure about that, I can check tomorrow unless someone knows for...
March 23, 2010 at 9:09 am
Is ABC set up as a master server? Or maybe msdb has at some point been restored from XYZ?
John
March 23, 2010 at 8:56 am
muthukkumaran (3/23/2010)
Use the alter database method instead of detach/attach.Write a dynamic sql script to move the files.
First try to do in your Dev/test server.
This is one way of doing it,...
March 23, 2010 at 8:41 am
Or you can install the client components on your desktop computer. This has the following advantages:
(1) You're not logged on to the server and stopping someone who needs to...
February 15, 2010 at 8:32 am
As Muthukumaran suggests, it may turn out that your only option is to get a bigger disk. This is because your log file needs to have at least enough...
December 23, 2009 at 8:22 am
It might be worth setting minumum server memory as well. That way, if anything is trying to grab memory back, it won't be able to. Also, are you...
December 18, 2009 at 6:12 am
Why do you say there'll be a performance loss on commit if the log is getting cleared (of inactive portions only) on a checkpoint?
Got some tests that show the performance...
November 10, 2009 at 8:29 am
I can't find where it says that in SQL Server 2005 Books Online. I have the April 2006 edition. The closest I can find is the following:
If you...
October 1, 2009 at 1:40 am
I usually move them to different drives. There isn't any great dogma behind this - it's just that since I have data files on one drive and log files...
September 30, 2009 at 10:17 am
Our system drives are often created with very little spare space by the people who build the servers. We usually have no choice but to move the system database...
September 30, 2009 at 8:36 am
Two reasons I've seen for not being able to start SQL Server Agent:
(1) The location specified for the SQLAGENT.OUT log file is incorrect or the permissions on the location are...
September 28, 2009 at 8:53 am
Viewing 15 posts - 5,836 through 5,850 (of 7,191 total)