Viewing 15 posts - 646 through 660 (of 1,161 total)
Yes. It is possible. Here is the official documentation.
September 22, 2010 at 11:10 pm
You can take the backup to local drive and then move it to the network drive. With you can minimize the risk of having corrupt backup files
September 21, 2010 at 10:57 am
sp_helprevlogin does it well. Have a look at this.
September 21, 2010 at 9:24 am
You may find this article useful.
September 20, 2010 at 6:12 am
Try doing a CHECKDB on master
September 19, 2010 at 11:14 pm
Backups are never an overhead for a DBA! Explore the various options available in SSMS/Maintenance Plans to handle backups and clean up.
September 19, 2010 at 9:17 pm
You will select "Add node to.....". Please refer http://www.mssqltips.com/tip.asp?tip=1721
September 17, 2010 at 10:55 am
Small tweak to Oliiii's query will give the object name as well
Select object_name(object_id), STATS_DATE(object_id, stats_id) LastUpdate From sys.stats
September 17, 2010 at 10:49 am
I second Steve. It is not a good practice to copy the data files manually when the database is operational. There are be many unpleasant surprises later on. Best option...
September 17, 2010 at 10:06 am
Check if the SQL Server service account has privileges to the following registry key
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Providers
September 16, 2010 at 11:47 pm
Do a RESTORE HEADERONLY on the backup file. It should tell you whether the backup set is complete. If you see "INCOMPLETE" in the output, the backup file is bad
September 16, 2010 at 11:30 pm
Yes. You need to run setup.exe on both the nodes.
September 16, 2010 at 1:58 pm
Viewing 15 posts - 646 through 660 (of 1,161 total)