Viewing 15 posts - 496 through 510 (of 611 total)
I'd like you to think about this a Little differently:
a. Do the Contents of test.bat contain Windows-based scripts? If so, would it not be better to create a...
May 17, 2013 at 11:15 pm
I had this Problem some time ago when I created a maintenance plan for Backup All Databases under SQL Server 2005. Once I had created the Job and let...
May 17, 2013 at 11:07 pm
ramyours2003 (5/17/2013)
We donot have space in database ,and the disk is fulled because of mdf's . how to release space on the drive
SHRINK DATABASE, SHRINK FILE, add disks, partition...
May 17, 2013 at 11:01 pm
karthiks.840 (2/19/2013)
Hi,How would you handle moving a big database(say 200GB) to another drive with minimal time on a production server??
--
Regards,
Karthik
An option, should the SQL Server Versions be the same, is...
May 17, 2013 at 10:55 pm
john.knight-557608 (5/17/2013)
I went through a process just recently of renaming and moving a DB and used the old method of detach/attach, next time round I'll give this way...
May 17, 2013 at 10:50 pm
sqlnaive (5/17/2013)
kevaburg (5/16/2013)
arooj300I have a database whose size is almost 25 GB, there log size 18 GB and mdf file is 6.30 GB, and everyday millions of records is coming...
May 17, 2013 at 1:29 am
BlackHawk-17 (5/16/2013)
The data connections still point to the old server name and I haven't found an easy way to overcome this for maintenance plans.
Check the server name in sys.servers. ...
May 17, 2013 at 1:08 am
The SQL Server is NOT the instance. The SQL Server is the host upon 1-30 instances can reside. That should be made very clear.
Having done this several times,...
May 17, 2013 at 1:06 am
The metadata that describes the location of the databases and is used by jobs and maintenance plans is still intact. That is to say that your jobs and maintenance...
May 16, 2013 at 7:38 am
ben111 (4/6/2013)
May 16, 2013 at 7:32 am
OPC has got it. An SQL Server Agent job with BCP is definately the answer.
If however you have an Express version, I would recommend creating an OS-level Batch Job...
May 16, 2013 at 7:25 am
This does not need a purging mechanism!!! What is required here is a backup strategy that includes the transaction log. Simply purging by doing something like...
May 16, 2013 at 6:41 am
A strange phenomenon that I came across was based on the following error that occured directly after a server rename that was performed exactly as described in this article:
Server 'test-sql2'...
May 16, 2013 at 12:52 am
Thank you very much!
And yes....next time I will....
Regards,
Kev
May 13, 2013 at 5:45 am
To take this thread a little further, I have a problem reorganising the indexes on a particular table. This is the query I ran.....
SELECT object_id AS ObjectID,
...
May 13, 2013 at 5:31 am
Viewing 15 posts - 496 through 510 (of 611 total)