Viewing 15 posts - 106 through 120 (of 1,334 total)
Yes why not full backups. With SQL 2005, you can backup your Fts too. Try doing a full backup and restoration.
February 27, 2008 at 11:53 am
Verifying database backup file is one. Other is that just run a DBCC CHECKDB on the server database where the backup was taken. to see if there are any torn...
February 27, 2008 at 11:47 am
What is the hardware spec for this server. seeems 40Gb and 1 hour is too long for taking a backup.
February 27, 2008 at 11:45 am
I hope you are confusing yourself with SQL and windows backups.
February 27, 2008 at 11:43 am
When you mean SQL Server do you mean the databases or the SQL folders. If database you can backup using the backup database command. But before that is your database...
February 27, 2008 at 11:42 am
As mentioned by the previous user you can't do that wiwth a restore. You need to create a database, filegroups in it and move them one by one. This should...
February 27, 2008 at 11:40 am
All you need to do is move the user databases, script the jobs and run the the other server, move the logins. This hould do for you. all the logins...
February 27, 2008 at 11:39 am
It depends on the number of transactions, size of transaction, recovery model, usage of temporary objects, etc. Also depends on the size of the table.
February 27, 2008 at 10:37 am
You create a windows alert with NET SEND MSG when sql services stops and starts.
February 27, 2008 at 10:36 am
Check if thie link below helps you.
http://sql-articles.com/index.php?page=articles/dpart.htm&PHPSESSID=4cd6af148294965cf66fe16d4428d396
February 27, 2008 at 10:35 am
Do a bi-weekly schedule for this. and in non production week end nights should be the best tim for these tasks.
February 27, 2008 at 10:30 am
February 27, 2008 at 10:26 am
You can define the job step to goto the mail when it fails and end succeed. this should be so simple in your case.
February 27, 2008 at 10:25 am
Do a bi-weekly schedule and that too on non-production hours mostly prefer week ends nights to do these kind of tasts in my servers.
February 27, 2008 at 10:23 am
Viewing 15 posts - 106 through 120 (of 1,334 total)