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,280 reads
2008-12-17 (first published: 2008-11-10)
2,695 reads
2008-12-17
116 reads
Save the transaction log and truncate the file to prevent Tlogs FULL Error
2008-12-16 (first published: 2008-11-17)
2,707 reads
Use this to find Data, Log, Backup, and Binn Directory for SQL Server 2005
2008-12-15 (first published: 2008-11-18)
1,667 reads
Change owner of a maintenance plan so the SQL Agent jobs have the correct owner for running.
2008-12-12
3,194 reads
2008-12-12 (first published: 2008-11-19)
865 reads
Generates a dataset for determining when subscriptions fail to send e-mail or post reports to file shares.
2008-12-10 (first published: 2008-11-19)
1,314 reads
2008-12-08 (first published: 2008-11-07)
477 reads
A quick way to get a snapshot of what data types are being used in all user tables.
2008-12-04 (first published: 2008-10-02)
1,121 reads
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
WhatsApp 082225313145 PPCR+MQ6, Jl. Raya Darmo No.5, Keputran, Kec. Tegalsari, Surabaya, Jawa Timur 60265
WhatsApp 082225313145 Jl. Dr. Soetomo No.118, Darmo, Kec. Wonokromo, Surabaya, Jawa Timur 60241
Comments posted to this topic are about the item Admin Rights for Everyone
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers