moving tempdb Microsoft SQl server 2000 2005
- No Comments
- Dec, 01, 2009
- Angelo Schalley
- MS SQL
check to see what the setting is right now :
USE tempdb
GO
EXEC sp_helpfile
GO
after checking, change the location acording
USE master
GO
ALTER DATABASE tempdb
MODIFY FILE (NAME = tempdev, FILENAME = ‘D:\tempdb.mdf’)
GO
ALTER DATABASE tempdb
MODIFY FILE (NAME = templog, FILENAME = ‘D:\templog.ldf’)
GO
Read more on moving tempdb Microsoft SQl server 2000 2005…
Microsoft SQL 2005 backup / replace script
- No Comments
- Oct, 05, 2009
- Angelo Schalley
- MS SQL
USE database;
GO
BACKUP DATABASE database
TO DISK = ‘Y:\MSSQL_copy\database.Bak’
WITH FORMAT,
MEDIANAME = ‘databasebackup’,
NAME = ‘Full Backup off database’;
GO
RESTORE FILELISTONLY
FROM DISK = ‘Y:\MSSQL_copy\database.Bak’
Read more on Microsoft SQL 2005 backup / replace script…
Categories
