Viewing 15 posts - 106 through 120 (of 1,335 total)
Is this an ORACLE qns?
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 27, 2008 at 11:54 am
Yes why not full backups. With SQL 2005, you can backup your Fts too. Try doing a full backup and restoration.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
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...
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
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.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 27, 2008 at 11:45 am
I hope you are confusing yourself with SQL and windows backups.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
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...
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
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...
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
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...
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
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.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 27, 2008 at 10:37 am
You create a windows alert with NET SEND MSG when sql services stops and starts.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
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
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
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.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 27, 2008 at 10:30 am
Refer the post
http://www.sqlservercentral.com/Forums/Topic460303-146-1.aspx#bm461011
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
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.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
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.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 27, 2008 at 10:23 am
Viewing 15 posts - 106 through 120 (of 1,335 total)