I couldn't find a solid script for this so I put this together. It creates the database EXACTLY as it was with growth and proper file groups.
2008-12-18 (first published: 2008-11-14)
1,272 reads
This article shows how a database can be restored to achieve point in time recovery
2008-11-12
2,951 reads
Is there a way I can automate a file deletion process from within SQL Server?
2008-11-11
4,819 reads
There are a lot of scripts out there that will allow you to use the msdb to auto-generate restore scripts, but what if you cannot access the msdb database. What is the easiest way to make sure I have the proper restore scripts on hand without relying on the msdb database?
2008-11-07
3,562 reads
This article will tell you about some ways of taking all databases backup using one single command.
2008-11-07
13,696 reads
This article discusses in detail the three database recovery models and how to choose the appropriate recovery model
2008-10-30
2,867 reads
As a DBA you need to ensure that the databases you manage are backed up regularly. This article details the importance of database backups and a recovery plan
2008-10-15
2,652 reads
Script to found out how much time before Restore or Backup Process remain
2008-11-17 (first published: 2008-09-30)
1,062 reads
Continuing on with his series on the basics of being a DBA, the MAK brings us an article that shows how to restore a backup to a new database.
2008-09-30
7,077 reads
One of the ongoing challenges of a DBA is to backup and restore databases. Backups are done on an automated schedule, but restores can take on many different versions, you may need to restore a production database, restore a development or test database or just create another copy of the database somewhere else. There are several ways of automating the restore process and creating a script, but this approach shows a way this can be done by just reading the contents of a directory for the backup files that exist.
2008-09-29
4,985 reads
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Comments posted to this topic are about the item Going Native with Fabric Spark...
Which of these are valid OPENQUERY() uses?
See possible answers