Forum Replies Created
Viewing 15 posts - 5,956 through 5,970 (of 7,499 total)
-
RE: How to query file name used for a particular backup?
Still early on the day
SELECT BS.database_name
, BMF.physical_device_name
, BMF.device_type
FROM msdb.dbo.backupset BS
INNER JOIN msdb.dbo.backupfile BF
ON BF.backup_set_id = BS.backup_set_id
INNER JOIN msdb.dbo.backupmediafamily BMF
on BMF.media_set_id = BS.backup_set_id...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: How to query file name used for a particular backup?
SELECT BS.database_name
, BF.physical_name
FROM msdb.dbo.backupset BS
INNER JOIN msdb.dbo.backupfile BF
ON BF.backup_set_id = BS.backup_set_id
WHERE BS.database_name = 'MyDB'
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Optimizations job error message
- If you're using a "sqlserver maintenance plan", it will optimize _all_ objects of the selected databases.
- verify that they don't drop and recreate their tablesat runtime ! because then...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: permission to access .BAK files for test restore
- your sqlserver-serviceaccount or your sqlagent's (if you're using a job) need read-auth for the .bak-file
- you as sql-user ... you need to be at least db-creator or database-owner...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Optimizations job error message
This is one of the enoying things where they use actual "work"-tables in stead of #-temp-tables.
So the create them on the fly, use them and drop the at the end...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Error 21776: [SQL-DMO] The name ''''dbo'''' was not found in the Users collection
use exec sp_changedbowner 'sa', true.
Keep in mind this is one of the flaws of EM. You'll have to disconnect an reconnect to see the correct results.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: permission to access .BAK files for test restore
If you want to restore using EM, you'll need to have the backup-file(s) at the server itself.
If your bak-files are on a remote location, you can use e.g. QA and...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: change name on server running SQL2000 and Biztalk
check http://www.databasejournal.com/scripts/article.php/1496451
to apply the rename of your windows server in your sqlserver instance.
According to my biztalk-admin changing the biztalksettings to connect to the new servername should be a peice...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Achieving Repeatable Reads in Snpashot Isolation
- Oracle does not have locking, it has versioning ! Different concept.
- SQL2005 Snapshot isolation level mimics this behaviour.
maybe these art. clarify a bit :
http://www.databasejournal.com/features/mssql/article.php/3560451
http://msdn2.microsoft.com/en-us/library/ms130975.aspx
http://msdn2.microsoft.com/en-us/library/ms189050.aspx
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: The lady vanishes...(her row!!)
If you're alowed, you could also quickly create a delete-trigger to log all deletes from that table (maybe even narrowing the rows to the ones you want to) into a audit-table....
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Attach Database: specify database owner
after the attatch you'll have to use this :
use yourdb
exec sp_changedbowner @loginame = 'sa' ,@map = 'true'
Also keep in mind EM does not refresh db-owner info ! You'll have to...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Help filtering important details from system table data
how about just adding startupparameters to your sqlserverinstance ?
add -T1204 and -T3605 so deadlock info lis logged into the sqlserver errorlog.
(
1204 Returns the type of lock participating in the deadlock... Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Access to SQL Server: The Upsizing Wizard
Today, your article was one of the featured articles with the newsletter.
Since your filed the article in 2005, things have changed.
Now you have the...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Get latest record without timestamp
actualy it is a common pitfall to determine "age"/"most recent",.. based on an autonumber !
Add a datetime-column with default getdate() or getUTCdate().
I takes 8 bytes a row, but at least you...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Move a database between two hard drives
just to add ...
there are special procedures to move master, model, tempdb and msdb.
check out bol or msdn (I cannot recall the KB wright now)
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
Viewing 15 posts - 5,956 through 5,970 (of 7,499 total)