Viewing 15 posts - 16 through 30 (of 171 total)
You are pointing to (use the use statement) the correct database where this Invoice table exists, correct?
July 12, 2018 at 8:06 am
For the Logins, you could use sp_help_revlogin to script the logins from the source and create them on the destination. For the Sql Server jobs, you can script out all...
June 7, 2018 at 8:12 am
Hi Mike,
To restore a database to an AOAG cluster, you would:
1) Remove the database from Availability Group
2) Drop the database on the Secondary
3) Restore the database on...
May 1, 2018 at 10:59 am
You won't see the available space after deleting data until a shrink occurs. Most experts agree, as long as this is a one-time shrink, and the data is not expected to grow...
April 4, 2018 at 2:37 pm
If I was in this situation, I would not add additional data files to tempdb for the reason of avoiding the IO messages in the sql error log. I would...
March 7, 2018 at 9:06 am
Experts say, rather than do a verify, simply prove the backup is a good one completely by restoring it, where if the restore is successful, you've proved the backup is...
February 28, 2018 at 2:44 pm
From Management Studio - go to the properties of the Availability Group, under the general tab, in the Availability Replicas section under Availability Mode.
January 31, 2018 at 7:25 am
When we did a similar thing, we simply stopped the connectivity of the applications to the databases first, then went into FCM (Failover Cluster Manager) and executed a "Stop Role"...
January 18, 2018 at 12:50 pm
I would start here - https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/start-stop-pause-resume-restart-sql-server-services
January 3, 2018 at 7:31 am
I think you will find if you set the Database Compatibility level in the options of the database you are running the query against to Sql Server 2008 R2 (the old...
November 20, 2017 at 8:32 am
We always used add/remove programs to uninstall. You may have to reboot after each remove and revisit add/remove programs afterwards until anything with "sql" in the name no longer exists...
October 4, 2017 at 12:33 pm
If you are concerned with the number of VLFs a database has as too many, we handle that by setting up a job which counts the number of VLFs per...
September 18, 2017 at 8:04 am
You may be able to follow some of these steps. Based on your comments, each step may or may not apply depending on if the disk was ever properly presented to...
September 18, 2017 at 7:47 am
Just to add, as far as changing database owners, one thing we noticed when we changed the owner of the databases to 'sa', the previous owner which was removed as...
September 13, 2017 at 12:08 pm
Viewing 15 posts - 16 through 30 (of 171 total)