Tagged Questions
1
vote
1answer
75 views
Can I split open/divide a large MS SQL disk media set?
MSSQL 2005
An old maintenance plan was backing up a database to a single disk based media set with append. It contains numerous full backups of about 2GB each. I now have a single media set file ...
4
votes
1answer
55 views
Restore database from backup file, where file name matches reg expression
I am doing the below :
RESTORE DATABASE UAT
FROM DISK = 'E:\Databases\backup\MY_LIVE_20120720_070001.bak'
WITH REPLACE
But I want to be able to use a file location that ignores the numbers in the ...
2
votes
1answer
484 views
How can I create a database backup replacing the previously created backup file?
If I backup my SQL Server 2008 R2 database with the following command
set @BackupFileName = N'C:\backup\Production-db.BAK' BACKUP DATABASE
[Production-db] TO DISK = @BackupFileName
and run the ...
1
vote
1answer
43 views
SQL Server database backups storage
This is rather basic question.
We do backups of all the databases on the server and size around 20GB every week.
All that is scheduled (shrinking,Backing up)
We store them on Network drive.
Now ...
0
votes
3answers
125 views
T-SQL query to schedule the back-up by using Transactional logs!sql server 2008
Hello i am new to sql server and i don't know any thing about backing up database using tsql i am trying to find out the procedure to do following but unsuccessful.
T-SQL query to schedule the ...
