Viewing 15 posts - 16 through 30 (of 394 total)
at my previous job we run it in a few ways:
If all databases are located on the same server and scripts are relatively small, then you can run master..sp_MSForeachdb.
For...
August 16, 2017 at 9:11 pm
April 29, 2017 at 5:00 am
We are using Foglight and quite happy with that tool. The more licenses you are going to purchase, the better deal you can strike.
April 28, 2017 at 5:06 am
Well, we are using LiteSpeed Bckup, so yes, backup is compressed.
Is the matter of fact local backup takes longer to perform (couple minutes extra) than network backup.
We have pretty good...
November 3, 2016 at 11:11 pm
Copy part took about 15mins earlier today.
Network Backup takes about 22-24mins for 750GB Database using LiteSpeed Backup.
October 30, 2016 at 8:43 pm
In that particular case, after the local backup, as the next step, we copy the local backup to the network share. Besides that, we also run a network backup...
October 29, 2016 at 8:22 pm
Local Backup of 750GB database (using LiteSpeed) takes about 30 mins
October 28, 2016 at 9:27 pm
I have 2 SQL Servers strictly for Developers where Developers can keep their copies of various Production databases. Each Developer can have as many 2 databases of each type across...
October 28, 2016 at 8:23 pm
We are using Foglight to monitor 30 Production instances and quite happy with it. And it has web interface. Plus with a new Web version, installation is easier than it...
October 29, 2015 at 1:50 am
I use LiteSpeed for over 10 years and quite happy with it. One of our databases is about 350GB and the compressed backup size is about 30GB. Of course it...
February 13, 2015 at 6:06 pm
We use linked servers for that, when job is running on only one DBA monitoring Server. However we are still using one Stored Procs across all servers to complement space...
February 11, 2015 at 7:17 pm
I usually use the below code before restore:
alter database Test
set offline with rollback immediate
December 24, 2014 at 6:30 pm
Viewing 15 posts - 16 through 30 (of 394 total)