Viewing 15 posts - 121 through 135 (of 266 total)
February 7, 2018 at 6:40 am
February 7, 2018 at 5:50 am
February 7, 2018 at 5:42 am
Just to add, why are you using 2008? It's 10 years old now and not supported. Do you have the option to use a more up to date version or...
February 7, 2018 at 5:22 am
Which objects have not been restored? You can bring the logins across using sp_help_revlogin and as for the jobs you can just script those out.
Thnanks
February 7, 2018 at 5:19 am
There is no point on a page count of 26 and I think Ola's scripts will only run when it's over 1000 pages (not 100% sure on this though).
Generally...
February 5, 2018 at 6:26 am
It will contain all the changes from the last full backup. If you need to restore your database you will need to restore the full backup plus the most recent...
January 24, 2018 at 3:35 am
Sorry, I've just seen you said it was standard edition. I'm pretty sure TDE is not available in standard edition. When I have a few minutes spare I'll double check...
January 24, 2018 at 2:57 am
What edition are you running? You can run the following to find out.
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
Thanks
January 24, 2018 at 2:54 am
There is a tool from Redgate called SQL Compare that can do this. I'm not aware of any free products but someone else might be.
Thanks
January 19, 2018 at 7:21 am
You only need to run it once on master and then run the script that is created on your new instance. You will need to look at also scripting out...
January 19, 2018 at 6:54 am
You first need to look at restricting the user permissions so they are unable to take a database offline. No users should be able to do this.
Thanks
January 9, 2018 at 12:49 am
January 4, 2018 at 4:51 am
Viewing 15 posts - 121 through 135 (of 266 total)